<?xml version="1.0" encoding="iso-8859-1" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content=
    "application/xhtml+xml; charset=iso-8859-1" />
    <title>
      unixODBC-2.3.7
    </title>
    <link rel="stylesheet" type="text/css" href="../stylesheets/lfs.css" />
    <meta name="generator" content="DocBook XSL Stylesheets V1.79.1" />
    <link rel="stylesheet" href="../stylesheets/lfs-print.css" type=
    "text/css" media="print" />
  </head>
  <body class="blfs" id="blfs-9.1">
    <div class="navheader">
      <h4>
        Beyond Linux<sup>�</sup> From Scratch <span class="phrase">(System
        V</span> Edition) - Version 9.1
      </h4>
      <h3>
        Chapter&nbsp;11.&nbsp;General Utilities
      </h3>
      <ul>
        <li class="prev">
          <a accesskey="p" href="tree.html" title="tree-1.8.0">Prev</a>
          <p>
            tree-1.8.0
          </p>
        </li>
        <li class="next">
          <a accesskey="n" href="xdg-user-dirs.html" title=
          "Xdg-user-dirs-0.17">Next</a>
          <p>
            Xdg-user-dirs-0.17
          </p>
        </li>
        <li class="up">
          <a accesskey="u" href="genutils.html" title=
          "Chapter&nbsp;11.&nbsp;General Utilities">Up</a>
        </li>
        <li class="home">
          <a accesskey="h" href="../index.html" title=
          "Beyond Linux� From Scratch     (System V Edition) - Version 9.1">Home</a>
        </li>
      </ul>
    </div>
    <div class="sect1" lang="en" xml:lang="en">
      <h1 class="sect1">
        <a id="unixodbc" name="unixodbc"></a>unixODBC-2.3.7
      </h1>
      <div class="package" lang="en" xml:lang="en">
        <h2 class="sect2">
          Introduction to unixODBC
        </h2>
        <p>
          The <span class="application">unixODBC</span> package is an Open
          Source ODBC (Open DataBase Connectivity) sub-system and an ODBC SDK
          for Linux, Mac OSX, and UNIX. ODBC is an open specification for
          providing application developers with a predictable API with which
          to access data sources. Data sources include optional SQL Servers
          and any data source with an ODBC Driver. <span class=
          "application">unixODBC</span> contains the following components
          used to assist with the manipulation of ODBC data sources: a driver
          manager, an installer library and command line tool, command line
          tools to help install a driver and work with SQL, drivers and
          driver setup libraries.
        </p>
        <p>
          This package is known to build and work properly using an LFS-9.1
          platform.
        </p>
        <h3>
          Package Information
        </h3>
        <div class="itemizedlist">
          <ul class="compact">
            <li class="listitem">
              <p>
                Download (FTP): <a class="ulink" href=
                "ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.7.tar.gz">ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.7.tar.gz</a>
              </p>
            </li>
            <li class="listitem">
              <p>
                Download MD5 sum: 274a711b0c77394e052db6493840c6f9
              </p>
            </li>
            <li class="listitem">
              <p>
                Download size: 1.6 MB
              </p>
            </li>
            <li class="listitem">
              <p>
                Estimated disk space required: 34 MB
              </p>
            </li>
            <li class="listitem">
              <p>
                Estimated build time: 0.2 SBU (using parallelism=4)
              </p>
            </li>
          </ul>
        </div>
        <h3>
          unixODBC Dependencies
        </h3>
        <h4>
          Optional
        </h4>
        <p class="optional">
          <a class="ulink" href=
          "http://www.hughes.com.au/products/msql/">Mini SQL</a> and
          <a class="xref" href="pth.html" title="Pth-2.0.7">Pth-2.0.7</a>
        </p>
        <p class="usernotes">
          User Notes: <a class="ulink" href=
          "http://wiki.linuxfromscratch.org/blfs/wiki/unixodbc">http://wiki.linuxfromscratch.org/blfs/wiki/unixodbc</a>
        </p>
      </div>
      <div class="installation" lang="en" xml:lang="en">
        <h2 class="sect2">
          Installation of unixODBC
        </h2>
        <p>
          Install <span class="application">unixODBC</span> by running the
          following commands:
        </p>
        <pre class="userinput">
<kbd class="command">./configure --prefix=/usr \
            --sysconfdir=/etc/unixODBC &amp;&amp;
make</kbd>
</pre>
        <p>
          This package does not come with a test suite.
        </p>
        <p>
          Now, as the <code class="systemitem">root</code> user:
        </p>
        <pre class="root">
<kbd class="command">make install &amp;&amp;

find doc -name "Makefile*" -delete                &amp;&amp;
chmod 644 doc/{lst,ProgrammerManual/Tutorial}/*   &amp;&amp;

install -v -m755 -d /usr/share/doc/unixODBC-2.3.7 &amp;&amp;
cp      -v -R doc/* /usr/share/doc/unixODBC-2.3.7</kbd>
</pre>
      </div>
      <div class="commands" lang="en" xml:lang="en">
        <h2 class="sect2">
          Command Explanations
        </h2>
        <p>
          <code class="option">--enable-drivers</code>: This parameter
          enables building the drivers that were installed by default in
          previous versions.
        </p>
        <p>
          <code class="option">--enable-drivers-conf</code>: This parameter
          enables building the driver configuration libraries that were
          installed by default in previous versions.
        </p>
      </div>
      <div class="configuration" lang="en" xml:lang="en">
        <h2 class="sect2">
          Configuring unixODBC
        </h2>
        <div class="sect3" lang="en" xml:lang="en">
          <h3 class="sect3">
            <a id="unixodbc-config" name="unixodbc-config"></a>
          </h3>
          <h4 class="title">
            <a id="unixodbc-config" name="unixodbc-config"></a>Config Files
          </h4>
          <p>
            <code class="filename">/etc/unixODBC/*</code>
          </p>
        </div>
        <div class="sect3" lang="en" xml:lang="en">
          <h3 class="sect3"></h3>
          <h4 class="title">
            <a id="idm45779272113216" name=
            "idm45779272113216"></a>Configuration Information
          </h4>
          <p>
            The files in <code class="filename">/etc/unixODBC</code> are
            meant to be configured by the system administrator (or the ODBC
            site administrator if appropriate privileges are granted to
            <code class="filename">/etc/unixODBC</code>). These files are not
            meant to be directly edited. The ODBC installer library is
            responsible for reading and writing the <span class=
            "application">unixODBC</span> config files.
          </p>
          <p>
            Unfortunately, there are not many <span class=
            "command"><strong>man</strong></span>, or any <span class=
            "command"><strong>info</strong></span> pages for the various
            programs available in the <span class=
            "application">unixODBC</span> package. Along with the information
            in the <span class="quote">&ldquo;<span class="quote">Short
            Descriptions</span>&rdquo;</span> below and the documentation
            installed in <code class=
            "filename">/usr/share/doc/unixODBC-2.3.7</code>, there are many
            <code class="filename">README</code> files throughout the source
            tree where the use and functionality of the programs can be
            found. Additionally, you can use the parameter <code class=
            "option">-?</code> for syntax and usage information. Lastly, the
            <span class="application">unixODBC</span> web site at <a class=
            "ulink" href=
            "http://www.unixodbc.org/">http://www.unixodbc.org/</a> has very
            good information.
          </p>
        </div>
      </div>
      <div class="content" lang="en" xml:lang="en">
        <h2 class="sect2">
          Contents
        </h2>
        <div class="segmentedlist">
          <div class="seglistitem">
            <div class="seg">
              <strong class="segtitle">Installed Programs:</strong>
              <span class="segbody">dltest, isql, iusql, odbc_config,
              odbcinst, and slencheck</span>
            </div>
            <div class="seg">
              <strong class="segtitle">Installed Libraries:</strong>
              <span class="segbody">libodbc.so, libodbccr.so, and
              libodbcinst.so</span>
            </div>
            <div class="seg">
              <strong class="segtitle">Installed Directories:</strong>
              <span class="segbody">/etc/unixODBC and
              /usr/share/doc/unixODBC-2.3.7</span>
            </div>
          </div>
        </div>
        <div class="variablelist">
          <h3>
            Short Descriptions
          </h3>
          <table border="0" class="variablelist">
            <colgroup>
              <col align="left" valign="top" />
              <col />
            </colgroup>
            <tbody>
              <tr>
                <td>
                  <p>
                    <a id="dltest" name="dltest"></a><span class=
                    "term"><span class=
                    "command"><strong>dltest</strong></span></span>
                  </p>
                </td>
                <td>
                  <p>
                    is a utility used to check a shared library to see if it
                    can be loaded and if a given symbol exists in it.
                  </p>
                </td>
              </tr>
              <tr>
                <td>
                  <p>
                    <a id="isql" name="isql"></a><span class=
                    "term"><span class=
                    "command"><strong>isql</strong></span></span>
                  </p>
                </td>
                <td>
                  <p>
                    is a utility which can be used to submit SQL to a data
                    source and to format/output results. It can be used in
                    batch or interactive mode.
                  </p>
                </td>
              </tr>
              <tr>
                <td>
                  <p>
                    <a id="iusql" name="iusql"></a><span class=
                    "term"><span class=
                    "command"><strong>iusql</strong></span></span>
                  </p>
                </td>
                <td>
                  <p>
                    provides the same functionality as the <span class=
                    "command"><strong>isql</strong></span> program.
                  </p>
                </td>
              </tr>
              <tr>
                <td>
                  <p>
                    <a id="odbc_config" name="odbc_config"></a><span class=
                    "term"><span class=
                    "command"><strong>odbc_config</strong></span></span>
                  </p>
                </td>
                <td>
                  <p>
                    is used to find out details about the installation of the
                    <span class="application">unixODBC</span> package.
                  </p>
                </td>
              </tr>
              <tr>
                <td>
                  <p>
                    <a id="odbcinst" name="odbcinst"></a><span class=
                    "term"><span class=
                    "command"><strong>odbcinst</strong></span></span>
                  </p>
                </td>
                <td>
                  <p>
                    is a utility created for install script/RPM writers. It
                    is a command line interface to key functionality in the
                    <code class="filename">libodbcinst</code> library. It
                    does not copy any files (i.e., libraries) but it will
                    modify the ODBC System Information for the user.
                  </p>
                </td>
              </tr>
              <tr>
                <td>
                  <p>
                    <a id="slencheck" name="slencheck"></a><span class=
                    "term"><span class=
                    "command"><strong>slencheck</strong></span></span>
                  </p>
                </td>
                <td>
                  <p>
                    is a utility which attempts to check whether an ODBC
                    driver was built with 32-bit or 64-bit SQLLEN types.
                  </p>
                </td>
              </tr>
            </tbody>
          </table>
        </div>
      </div>
      <p class="updated">
        Last updated on 2020-02-17 12:03:00 -0800
      </p>
    </div>
    <div class="navfooter">
      <ul>
        <li class="prev">
          <a accesskey="p" href="tree.html" title="tree-1.8.0">Prev</a>
          <p>
            tree-1.8.0
          </p>
        </li>
        <li class="next">
          <a accesskey="n" href="xdg-user-dirs.html" title=
          "Xdg-user-dirs-0.17">Next</a>
          <p>
            Xdg-user-dirs-0.17
          </p>
        </li>
        <li class="up">
          <a accesskey="u" href="genutils.html" title=
          "Chapter&nbsp;11.&nbsp;General Utilities">Up</a>
        </li>
        <li class="home">
          <a accesskey="h" href="../index.html" title=
          "Beyond Linux� From Scratch     (System V Edition) - Version 9.1">Home</a>
        </li>
      </ul>
    </div>
  </body>
</html>
